Film_Locations_in_San_Francisco

7 rows where Actor 3 = 501

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
905	905	Mrs. Doubtfire 170	1993 46	1200 Washington Street at Taylor Street		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Chris Columbus 31	Randi Mayem Singer 149	Robin Williams 265	Sally Field 100	Pierce Brosnan 501
906	906	Mrs. Doubtfire 170	1993 46	Hancock School (940 Filbert Street)		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Chris Columbus 31	Randi Mayem Singer 149	Robin Williams 265	Sally Field 100	Pierce Brosnan 501
907	907	Mrs. Doubtfire 170	1993 46	Danilo's Bakery (Green Street & Bannam Place)		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Chris Columbus 31	Randi Mayem Singer 149	Robin Williams 265	Sally Field 100	Pierce Brosnan 501
908	908	Mrs. Doubtfire 170	1993 46	Chrissy Field	Chrissy Field was originally an airfield for the Presidio Army Base.	Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Chris Columbus 31	Randi Mayem Singer 149	Robin Williams 265	Sally Field 100	Pierce Brosnan 501
909	909	Mrs. Doubtfire 170	1993 46	520-522A Green Street at Grant Street		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Chris Columbus 31	Randi Mayem Singer 149	Robin Williams 265	Sally Field 100	Pierce Brosnan 501
910	910	Mrs. Doubtfire 170	1993 46	516 Green Street		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Chris Columbus 31	Randi Mayem Singer 149	Robin Williams 265	Sally Field 100	Pierce Brosnan 501
911	911	Mrs. Doubtfire 170	1993 46	100 Embarcadero Street		Twentieth Century Fox Film Corporation 13	Twentieth Century Fox Film Corporation 12	Chris Columbus 31	Randi Mayem Singer 149	Robin Williams 265	Sally Field 100	Pierce Brosnan 501

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");